﻿CREATE PROCEDURE [dbo].[yaf_nntpserver_delete](
                @NntpServerID INT)
AS
    BEGIN
        DELETE FROM yaf_NntpTopic
        WHERE       NntpForumID IN (SELECT NntpForumID
                        FROM   yaf_NntpForum
                        WHERE  NntpServerID = @NntpServerID)
        DELETE FROM yaf_NntpForum
        WHERE       NntpServerID = @NntpServerID
        DELETE FROM yaf_NntpServer
        WHERE       NntpServerID = @NntpServerID
    END


